County Profile for Franklin - 2013



County Controls Information

Cost Report Counts Population
Total Hospital Count 1 Total Population on July 31, 2013 0
Total Cost Reports Filed in 2013 1 Total Births 0
Total Cost Reports Submitted 0 Total Deaths 0
Total Cost Reports Settled 1 Net Population Natural Change 0
Total Cost Reports Reopened 0 Total International Migration 0
Total Cost Reports Ammended 0 Total Domestic Migration 0
Total Cost Reports Audited 0 Total Residual 0
Net Population Change 0

County Financial Statements - Worksheet G

Balance Sheet Income Statement
Current Assets 21,505,767 Total Charges 189,178,867
Fixed Assets 32,726,472 Contract Allowance 117,645,705
Other Assets 696,456 Operating Revenue 71,533,162
Total Assets 54,928,695 Operating Expenses 78,572,692
Current Liabilities 13,565,591 Operating Margin -7,039,530
Long Term Liabilities 14,104,409 Other Income 6,136,320
Total Equity 27,258,695 Other Expense 0
Total Liabilities and Equity 54,928,695 Net Profit or Loss -903,210

County Calculations

Per Discharge Statistics Per Bed Statistics Per Person Statistics
Revenue per Discharge $18,508 Revenue per Bed $841,567 Revenue per Person $71,533,162
Net Margin per Discharge ($1,821) Net Margin per Bed ($82,818) Net Margin per Person ($7,039,530)
Net Profit per Discharge ($234) Net Profit per Bed ($10,626) Net Profit per Person ($903,210)
Net Fixed Assets per Discharge $8,467 Net Fixed Assets per Bed $385,017 Net Fixed Assets per Bed $32,726,472
Long Term Debt per Discharge $3,649 Long Term Debt per Bed $165,934 Long Term Debt per Person $14,104,409
Persons per Discharge 0 Persons per Bed 0
Occupancy Rate 49.6 %
Length of Stay 4 Days

County Ranking of Selected Values

Income Statement Balance Sheet Statistics
Total Charges 1,048 Net Fixed Assets 1,102 Population Estimate 1,151
Total Revenue 1,052 Long Term Liabilities 1,155 Total Patient Discharges 946
Net Margin 2,792 Total Patient Beds 1,035
Net Profit or Loss 2,777

County Charges and Direct Cost - Worksheet B and C

Line Description Direct Cost Charges Ratio
30 Adults and Pediatrics - General Routine Care 17,388,221 18,593,398 0.9352
31 Intensive Care Unit 2,582,892 2,696,598 0.9578
32 Coronary Care Unit 0 0
43 Nursery 717,069 1,400,875 0.5119
44 Skilled Nursing Care 0 0
50 Operating Room 1,893,124 3,366,724 0.5623
51 Recovery Room 1,831,605 3,473,270 0.5273
52 Labor and Delivery Room 433,223 4,614,191 0.0939

County General Service Cost - Worksheet A

Lines Description Amount Lines Description Amount
01 Capital Related - Building and Fixtures 3,045,803 13 Nursing Administration 891,881
02,03 Captial Related - Movable Equipment 1,711,047 14 Central Services and Supply 4,662,334
04 Employee Benefits 8,306,310 15 Pharmacy 5,225,508
05 Administrative and General 14,897,991 16 Medical Records and Medical Library 467,017
06 Maintenance and Repairs 4,160,711 17 Social Services 205,416
07 Operation of Plant 0 18 Other General Service Expense 0
08,09 Laundry, Linen and Housekeeping 1,101,592 19 Non Physician Anesthetist 0
10,11 Dietary and Cafeteria 1,161,780 20,21,22,23 Education Programs 0
Total General Service Cost Centers 45,837,390

County Profile for Franklin - 2013